package com.manhanlou.service;

import com.manhanlou.dao.EmployeeDao;
import com.manhanlou.dao.EmployeeInfoDao;
import com.manhanlou.domain.EmployeeInfo;

import java.util.List;

/**
 * @author wty
 * @date 2022/11/10 9:39
 */
public class EmployeeInfoService {
    private EmployeeInfoDao employeeInfoDao = new EmployeeInfoDao();

    public List<EmployeeInfo> queryPersonMange(String empId) {
        String sqlStr = "SELECT b.id,b.empId,b.name,b.job,b.`sex`," +
                "       b.`borndate`,b.`certno`,b.`study`,b.`marry`," +
                "       b.`phone`,b.`address`,b.`email`,b.`registertime`,b.`bz`" +
                "      FROM employeeInfo b where empId = ?";
        List<EmployeeInfo> list = employeeInfoDao.queryMulti(sqlStr, EmployeeInfo.class, empId);
        return list;
    }
}
